if object_id('CUnitInsert') is not null
	drop proc CUnitInsert
	
go

create proc CUnitInsert
	@Acronym nvarchar(8),
	@Name nvarchar(25)
as
begin
	insert into CUnit (Acronym, Name) values (@Acronym, @Name)
	select scope_identity()
end	
